*************************************
    conditional-sql-inserts.xml
*************************************

- Requires: Build 680 or later

- Skill Level: low


Sometimes we only want to update the database if a field
has a value. This is often the case when we have multiple
rows of the same table, differing only by the data.

Conditional statements allow us to create such logic by
checking a field and making sure it has a value in order to process.


*************************************
    sql_plus.xml
*************************************

- Requires: Build 680 or later

- Skill Level: medium


In this job we use Stored Procedures and CURSORS to
INSERT each checkbox item in its own row.


*************************************
    sql_plus.xml
*************************************

- Requires: Build 631 or later

- Skill Level: low


This job demonstrates the SQL+ module. It uses a
new database table only the most recent installs have: fb_demo.
If you do not have this table, please run this SQL aginst your
RackForms database:

CREATE TABLE fb_demo(
  id INT (11) NOT NULL AUTO_INCREMENT,
  name VARCHAR (50) DEFAULT NULL,
  age INT (11) DEFAULT NULL,
  email VARCHAR (50) DEFAULT NULL,
  pwd BINARY (100) DEFAULT NULL,
  image LONGBLOB DEFAULT NULL,
  PRIMARY KEY (id)
)
ENGINE = INNODB
AUTO_INCREMENT = 2
CHARACTER SET utf8
COLLATE utf8_general_ci;


This will create the SQL table so this job will work!



*************************************
    mysql-timestamps.xml
*************************************

- Requires: Build 653 or later

- Skill Level: low

We can now use the standard calendar fields to issue 
valid MySQL/MSSQL DATETIME and TIMESTAMP values. This
job shows the process of how this is done.

We also demo how we can create timestamps and datetime 
values from any field using a bit of custom PHP Top Code.



*************************************
    return_result.xml
*************************************

- Requires: Build 640 or later

- Skill Level: medium

This job shows how we can use the new SQL+ query function
to return results sets to us.

This is helpful for many things, one in particular is when you
are trying to write a custom message to a user in say, an EMAIL+
email, where the information you need is tucked away in a relational
database. For example, ket's say you have a SELECT item that lets
users choose a salesperson. Becuase the relational model we are writing 
to, we cannot use the SELECT box value, as that will be an INT value
as it needs to relate to another table. HOwever, we can use that 
INT value in an SQL+ SELECT query, which would allow us to 
grab the salespersons name base don that KEY.



*************************************
    insert_dates_to_mysql.xml
*************************************

- Requires: Build 623 or later

- Skill Level: medium

This user contributed job shows a technique we can use
to insert a date into MySQL. 




*************************************
    sql_plus_variable.xml
*************************************

- Requires: Build 612 or later

- Skill Level: medium

Using variables in your SQL+ statements is very common. This
jobs shows the basics of how we use such variables in RackForms.